package com.zzyl.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description UserRoleMapper
 * @Author fy
 * @Date 2025-05-23  21:30
 */
@Mapper
public interface UserRoleMapper {
    @Select("select sur.user_id from sys_user_role sur left join sys_role sr on sur.role_id = sr.id \n" +
            "where sr.role_name = #{roleName}")
    List<Long> selectByRoleName(String roleName);
}
